Instant KPI: From Data to Dashboard in Record Time

Moving from data to dashboard in a single program, this paper shows how Base SAS® and SAS/STAT® software can be used with the power of PROC GKPI to go from raw data to meaningful statistical summaries of benchmarked performance. Benchmarking is a common process by which organizations measure performance against group norms, past performance, or expected performance. For example, a school might compare its graduation rate against its school district’s rate, a hospital might compare care for an individual patient with patients with similar medical histories, or a retail store might compare itself to other franchises. Using PROC MEANS, PROC UNIVARIATE, and other summaries, you can calculate statistical boundaries on the fly, renorming data using group distributions, and publishing the results to the dashboard. This paper demonstrates how stored statistical procedures can be run automatically to generate valid comparison groups and report the resulting metrics, with appropriate statistical boundaries, using Output Delivery System (ODS) graphics ready for the SAS® Information Delivery Portal, any generic HTML dashboard, or offline reporting. Applications in several industries are discussed.